UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kh/VKG8VVhw8Imnw1dLMZtt78uuQinfRz67N1UFGnGc='
WHERE
key_id = 'c4677d6f4770427d0a2cd24a0c0982200ab3bef99642d073ad0103b1334000c6'
AND (
token = 'kh/VKG8VVhw8Imnw1dLMZtt78uuQinfRz67N1UFGnGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)